Tabela Document

Definicja tabeli Document

Name

Document

Code

Document

Comment

PL: Dane dokumentu (np. faktury)
EN: Document data (fe. Invoice)


Lista kolumn tabeli Document

Name

Code

DocumentID

DocumentID

DocumentTypeID

DocumentTypeID

ContractorID

ContractorID

IdentifierTypeID

IdentifierTypeID

ExternalValue

ExternalValue

PaymentTypeID

PaymentTypeID

PersonID

PersonID

ExportStatusID

ExportStatusID

EpisodeID

EpisodeID

DocumentKindID

DocumentKindID

ContractID

ContractID

PayerID

PayerID

SellerID

SellerID

DateValue

DateValue

SellDate

SellDate

PaymentDeadline

PaymentDeadline

Comments

Comments

Active

Active

InsPersonID

InsPersonID

AdvanceAmount

AdvanceAmount

InsertDT

InsertDT

PeriodStartDT

PeriodStartDT

PeriodStopDT

PeriodStopDT

GrossAmount

GrossAmount

VatAmount

VatAmount

NetAmount

NetAmount

PaidAmount

PaidAmount

OrdererID

OrdererID

ReceiptSettlementMethodID

ReceiptSettlementMethodID


Kolumna DocumentID tabeli Document

Definicja kolumny DocumentID tabeli Document

Name

DocumentID

Code

DocumentID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna DocumentTypeID tabeli Document

Definicja kolumny DocumentTypeID tabeli Document

Name

DocumentTypeID

Code

DocumentTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractorID tabeli Document

Definicja kolumny ContractorID tabeli Document

Name

ContractorID

Code

ContractorID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna IdentifierTypeID tabeli Document

Definicja kolumny IdentifierTypeID tabeli Document

Name

IdentifierTypeID

Code

IdentifierTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ExternalValue tabeli Document

Definicja kolumny ExternalValue tabeli Document

Name

ExternalValue

Code

ExternalValue

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna PaymentTypeID tabeli Document

Definicja kolumny PaymentTypeID tabeli Document

Name

PaymentTypeID

Code

PaymentTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PersonID tabeli Document

Definicja kolumny PersonID tabeli Document

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ExportStatusID tabeli Document

Definicja kolumny ExportStatusID tabeli Document

Name

ExportStatusID

Code

ExportStatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna EpisodeID tabeli Document

Definicja kolumny EpisodeID tabeli Document

Name

EpisodeID

Code

EpisodeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DocumentKindID tabeli Document

Definicja kolumny DocumentKindID tabeli Document

Name

DocumentKindID

Code

DocumentKindID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractID tabeli Document

Definicja kolumny ContractID tabeli Document

Name

ContractID

Code

ContractID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PayerID tabeli Document

Definicja kolumny PayerID tabeli Document

Name

PayerID

Code

PayerID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna SellerID tabeli Document

Definicja kolumny SellerID tabeli Document

Name

SellerID

Code

SellerID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID sprzedawcy


Kolumna DateValue tabeli Document

Definicja kolumny DateValue tabeli Document

Name

DateValue

Code

DateValue

Data Type

DATE

Mandatory

No

Comment

 


Kolumna SellDate tabeli Document

Definicja kolumny SellDate tabeli Document

Name

SellDate

Code

SellDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna PaymentDeadline tabeli Document

Definicja kolumny PaymentDeadline tabeli Document

Name

PaymentDeadline

Code

PaymentDeadline

Data Type

DATE

Mandatory

No

Comment

 


Kolumna Comments tabeli Document

Definicja kolumny Comments tabeli Document

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna Active tabeli Document

Definicja kolumny Active tabeli Document

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna InsPersonID tabeli Document

Definicja kolumny InsPersonID tabeli Document

Name

InsPersonID

Code

InsPersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AdvanceAmount tabeli Document

Definicja kolumny AdvanceAmount tabeli Document

Name

AdvanceAmount

Code

AdvanceAmount

Data Type

NUMBER(19,4)

Mandatory

No

Comment

Kwota zaliczki wymaganej przed przyjeciem pacjenta do szpitala na podstawie danego zamówienia na hospitalizacje / kwota zaliczki wplaconej na danej fakturrze zaliczkowej (faktura zaliczkowa <==>DocumentTypeID = 3)


Kolumna InsertDT tabeli Document

Definicja kolumny InsertDT tabeli Document

Name

InsertDT

Code

InsertDT

Data Type

DATE

Mandatory

No

Comment

PL: Data wstawienia rekordu
EN: Insert date of record
DE: Das Date der Ansatzstelle fur den Rekord


Kolumna PeriodStartDT tabeli Document

Definicja kolumny PeriodStartDT tabeli Document

Name

PeriodStartDT

Code

PeriodStartDT

Data Type

DATE

Mandatory

No

Comment

Poczatek okresu, którego dotyczy faktura


Kolumna PeriodStopDT tabeli Document

Definicja kolumny PeriodStopDT tabeli Document

Name

PeriodStopDT

Code

PeriodStopDT

Data Type

DATE

Mandatory

No

Comment

Koniec okresu, którego dotyczy faktura


Kolumna GrossAmount tabeli Document

Definicja kolumny GrossAmount tabeli Document

Name

GrossAmount

Code

GrossAmount

Data Type

NUMBER(19,4)

Mandatory

No

Comment

 


Kolumna VatAmount tabeli Document

Definicja kolumny VatAmount tabeli Document

Name

VatAmount

Code

VatAmount

Data Type

NUMBER(19,4)

Mandatory

No

Comment

 


Kolumna NetAmount tabeli Document

Definicja kolumny NetAmount tabeli Document

Name

NetAmount

Code

NetAmount

Data Type

NUMBER(19,4)

Mandatory

No

Comment

 


Kolumna PaidAmount tabeli Document

Definicja kolumny PaidAmount tabeli Document

Name

PaidAmount

Code

PaidAmount

Data Type

NUMBER(19,4)

Mandatory

No

Comment

kwota, która klient faktycznie zaplacil


Kolumna OrdererID tabeli Document

Definicja kolumny OrdererID tabeli Document

Name

OrdererID

Code

OrdererID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ReceiptSettlementMethodID tabeli Document

Definicja kolumny ReceiptSettlementMethodID tabeli Document

Name

ReceiptSettlementMethodID

Code

ReceiptSettlementMethodID

Data Type

NUMBER(10)

Mandatory

No

Comment

Sposób rozliczenia paragonu


Lista kluczy tabeli Document

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Document

Definicja klucza Identifier_1 tabeli Document

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment